<html><body>
<?
header("Content-Type: text/html; charset=utf-8");
$sessionID = $_GET['sessionID'];
$categorie = $_GET['categorie'];
$name = $_GET['name'];
$chapter = $_GET['chapter'];
$lat = $_GET['lat'];
$lon = $_GET['lon'];


$username="eu_wilhelm";
$password="n3DN67xcDwPyba4S";
$database="eu_wilhelm";


mysql_connect("gis-db.uni-muenster.de",$username,$password) or die("Connection failed: ". mysql_error());

@mysql_select_db($database) or die( "Unable to select the database: ". mysql_error());

$query = "INSERT INTO poiLogger (sessionID, categorie, name, chapter, lat, lon) VALUES('$sessionID', '$categorie', '$name', '$chapter', '$lat', '$lon');";

mysql_query($query) or die ("Query Error: " .mysql_error());

echo "Data inserted";

mysql_close();
 
?>
</body></html>